Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 119735 |
| Missing cells | 13587 |
| Missing cells (%) | 0.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 50.0 MiB |
| Average record size in memory | 437.8 B |
Variable types
| Text | 5 |
|---|---|
| DateTime | 1 |
| Numeric | 7 |
close is highly overall correlated with pre_settle and 1 other fields | High correlation |
open_interest is highly overall correlated with turnover and 1 other fields | High correlation |
pre_settle is highly overall correlated with close and 1 other fields | High correlation |
settle is highly overall correlated with close and 1 other fields | High correlation |
turnover is highly overall correlated with open_interest and 1 other fields | High correlation |
volume is highly overall correlated with open_interest and 1 other fields | High correlation |
open has 4529 (3.8%) missing values | Missing |
high has 4529 (3.8%) missing values | Missing |
low has 4529 (3.8%) missing values | Missing |
close has 3524 (2.9%) zeros | Zeros |
volume has 12864 (10.7%) zeros | Zeros |
open_interest has 6918 (5.8%) zeros | Zeros |
turnover has 12864 (10.7%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-21 02:22:39.420121 |
|---|---|
| Analysis finished | 2024-03-21 02:22:54.179358 |
| Duration | 14.76 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
symbol
Text
| Distinct | 2943 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.1 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.5656408 |
| Min length | 5 |
Characters and Unicode
| Total characters | 666402 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | a1103 |
|---|---|
| 2nd row | a1103 |
| 3rd row | a1103 |
| 4th row | a1103 |
| 5th row | a1103 |
| Value | Count | Frequency (%) |
| sc2109 | 691 | 0.6% |
| pm301 | 476 | 0.4% |
| oi309 | 472 | 0.4% |
| ri307 | 466 | 0.4% |
| wh307 | 466 | 0.4% |
| rs307 | 358 | 0.3% |
| fg305 | 338 | 0.3% |
| rm305 | 319 | 0.3% |
| jr403 | 312 | 0.3% |
| sr101 | 243 | 0.2% |
| Other values (2933) | 115594 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 121787 | |
| 0 | 119894 | |
| 2 | 70708 | 10.6% |
| 9 | 32235 | 4.8% |
| 5 | 30459 | 4.6% |
| 3 | 27942 | 4.2% |
| U | 17218 | 2.6% |
| 4 | 16721 | 2.5% |
| A | 15318 | 2.3% |
| R | 15063 | 2.3% |
| Other values (40) | 199057 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 666402 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 121787 | |
| 0 | 119894 | |
| 2 | 70708 | 10.6% |
| 9 | 32235 | 4.8% |
| 5 | 30459 | 4.6% |
| 3 | 27942 | 4.2% |
| U | 17218 | 2.6% |
| 4 | 16721 | 2.5% |
| A | 15318 | 2.3% |
| R | 15063 | 2.3% |
| Other values (40) | 199057 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 666402 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 121787 | |
| 0 | 119894 | |
| 2 | 70708 | 10.6% |
| 9 | 32235 | 4.8% |
| 5 | 30459 | 4.6% |
| 3 | 27942 | 4.2% |
| U | 17218 | 2.6% |
| 4 | 16721 | 2.5% |
| A | 15318 | 2.3% |
| R | 15063 | 2.3% |
| Other values (40) | 199057 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 666402 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 121787 | |
| 0 | 119894 | |
| 2 | 70708 | 10.6% |
| 9 | 32235 | 4.8% |
| 5 | 30459 | 4.6% |
| 3 | 27942 | 4.2% |
| U | 17218 | 2.6% |
| 4 | 16721 | 2.5% |
| A | 15318 | 2.3% |
| R | 15063 | 2.3% |
| Other values (40) | 199057 |
date
Date
| Distinct | 3203 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 935.6 KiB |
| Minimum | 2011-01-04 00:00:00 |
|---|---|
| Maximum | 2024-03-11 00:00:00 |
Histogram with fixed size bins (bins=50)
open
Text
MISSING
| Distinct | 23610 |
|---|---|
| Distinct (%) | 20.5% |
| Missing | 4529 |
| Missing (%) | 3.8% |
| Memory size | 7.1 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9791851 |
| Min length | 0 |
Characters and Unicode
| Total characters | 688838 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9442 ? |
|---|---|
| Unique (%) | 8.2% |
Sample
| 1st row | 4110.0 |
|---|---|
| 2nd row | 4122.0 |
| 3rd row | 4091.0 |
| 4th row | 4065.0 |
| 5th row | 4051.0 |
| Value | Count | Frequency (%) |
| 0.0 | 8314 | 7.2% |
| 3200.0 | 60 | 0.1% |
| 2950.0 | 52 | < 0.1% |
| 4400.0 | 48 | < 0.1% |
| 3600.0 | 48 | < 0.1% |
| 4150.0 | 48 | < 0.1% |
| 8600.0 | 47 | < 0.1% |
| 3680.0 | 47 | < 0.1% |
| 4250.0 | 46 | < 0.1% |
| 3750.0 | 45 | < 0.1% |
| Other values (23599) | 106425 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 183429 | |
| . | 115180 | |
| 1 | 56318 | 8.2% |
| 5 | 56030 | 8.1% |
| 2 | 50557 | 7.3% |
| 3 | 45403 | 6.6% |
| 4 | 42599 | 6.2% |
| 6 | 38466 | 5.6% |
| 8 | 38092 | 5.5% |
| 7 | 31943 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 688838 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 183429 | |
| . | 115180 | |
| 1 | 56318 | 8.2% |
| 5 | 56030 | 8.1% |
| 2 | 50557 | 7.3% |
| 3 | 45403 | 6.6% |
| 4 | 42599 | 6.2% |
| 6 | 38466 | 5.6% |
| 8 | 38092 | 5.5% |
| 7 | 31943 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 688838 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 183429 | |
| . | 115180 | |
| 1 | 56318 | 8.2% |
| 5 | 56030 | 8.1% |
| 2 | 50557 | 7.3% |
| 3 | 45403 | 6.6% |
| 4 | 42599 | 6.2% |
| 6 | 38466 | 5.6% |
| 8 | 38092 | 5.5% |
| 7 | 31943 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 688838 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 183429 | |
| . | 115180 | |
| 1 | 56318 | 8.2% |
| 5 | 56030 | 8.1% |
| 2 | 50557 | 7.3% |
| 3 | 45403 | 6.6% |
| 4 | 42599 | 6.2% |
| 6 | 38466 | 5.6% |
| 8 | 38092 | 5.5% |
| 7 | 31943 | 4.6% |
high
Text
MISSING
| Distinct | 24361 |
|---|---|
| Distinct (%) | 21.1% |
| Missing | 4529 |
| Missing (%) | 3.8% |
| Memory size | 7.1 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9829696 |
| Min length | 0 |
Characters and Unicode
| Total characters | 689274 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9669 ? |
|---|---|
| Unique (%) | 8.4% |
Sample
| 1st row | 4135.0 |
|---|---|
| 2nd row | 4122.0 |
| 3rd row | 4091.0 |
| 4th row | 4095.0 |
| 5th row | 4074.0 |
| Value | Count | Frequency (%) |
| 0.0 | 8314 | 7.2% |
| 4800.0 | 42 | < 0.1% |
| 4200.0 | 42 | < 0.1% |
| 2850.0 | 39 | < 0.1% |
| 3650.0 | 38 | < 0.1% |
| 4750.0 | 36 | < 0.1% |
| 3450.0 | 35 | < 0.1% |
| 3630.0 | 35 | < 0.1% |
| 3700.0 | 34 | < 0.1% |
| 4140.0 | 34 | < 0.1% |
| Other values (24350) | 106531 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 173563 | |
| . | 115180 | |
| 5 | 56498 | 8.2% |
| 1 | 54980 | 8.0% |
| 2 | 50077 | 7.3% |
| 4 | 46160 | 6.7% |
| 3 | 45848 | 6.7% |
| 8 | 39940 | 5.8% |
| 6 | 39562 | 5.7% |
| 9 | 34072 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 689274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 173563 | |
| . | 115180 | |
| 5 | 56498 | 8.2% |
| 1 | 54980 | 8.0% |
| 2 | 50077 | 7.3% |
| 4 | 46160 | 6.7% |
| 3 | 45848 | 6.7% |
| 8 | 39940 | 5.8% |
| 6 | 39562 | 5.7% |
| 9 | 34072 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 689274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 173563 | |
| . | 115180 | |
| 5 | 56498 | 8.2% |
| 1 | 54980 | 8.0% |
| 2 | 50077 | 7.3% |
| 4 | 46160 | 6.7% |
| 3 | 45848 | 6.7% |
| 8 | 39940 | 5.8% |
| 6 | 39562 | 5.7% |
| 9 | 34072 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 689274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 173563 | |
| . | 115180 | |
| 5 | 56498 | 8.2% |
| 1 | 54980 | 8.0% |
| 2 | 50077 | 7.3% |
| 4 | 46160 | 6.7% |
| 3 | 45848 | 6.7% |
| 8 | 39940 | 5.8% |
| 6 | 39562 | 5.7% |
| 9 | 34072 | 4.9% |
low
Text
MISSING
| Distinct | 24125 |
|---|---|
| Distinct (%) | 20.9% |
| Missing | 4529 |
| Missing (%) | 3.8% |
| Memory size | 7.1 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9765116 |
| Min length | 0 |
Characters and Unicode
| Total characters | 688530 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9584 ? |
|---|---|
| Unique (%) | 8.3% |
Sample
| 1st row | 4110.0 |
|---|---|
| 2nd row | 4085.0 |
| 3rd row | 4091.0 |
| 4th row | 4048.0 |
| 5th row | 4051.0 |
| Value | Count | Frequency (%) |
| 0.0 | 8314 | 7.2% |
| 4100.0 | 37 | < 0.1% |
| 3450.0 | 37 | < 0.1% |
| 3780.0 | 37 | < 0.1% |
| 2300.0 | 36 | < 0.1% |
| 2530.0 | 35 | < 0.1% |
| 2550.0 | 34 | < 0.1% |
| 4150.0 | 34 | < 0.1% |
| 4180.0 | 34 | < 0.1% |
| 4350.0 | 33 | < 0.1% |
| Other values (24114) | 106549 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 177012 | |
| . | 115180 | |
| 1 | 58279 | 8.5% |
| 5 | 56939 | 8.3% |
| 2 | 52742 | 7.7% |
| 3 | 47111 | 6.8% |
| 4 | 43373 | 6.3% |
| 6 | 40427 | 5.9% |
| 8 | 37271 | 5.4% |
| 7 | 32415 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 688530 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177012 | |
| . | 115180 | |
| 1 | 58279 | 8.5% |
| 5 | 56939 | 8.3% |
| 2 | 52742 | 7.7% |
| 3 | 47111 | 6.8% |
| 4 | 43373 | 6.3% |
| 6 | 40427 | 5.9% |
| 8 | 37271 | 5.4% |
| 7 | 32415 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 688530 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177012 | |
| . | 115180 | |
| 1 | 58279 | 8.5% |
| 5 | 56939 | 8.3% |
| 2 | 52742 | 7.7% |
| 3 | 47111 | 6.8% |
| 4 | 43373 | 6.3% |
| 6 | 40427 | 5.9% |
| 8 | 37271 | 5.4% |
| 7 | 32415 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 688530 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177012 | |
| . | 115180 | |
| 1 | 58279 | 8.5% |
| 5 | 56939 | 8.3% |
| 2 | 52742 | 7.7% |
| 3 | 47111 | 6.8% |
| 4 | 43373 | 6.3% |
| 6 | 40427 | 5.9% |
| 8 | 37271 | 5.4% |
| 7 | 32415 | 4.7% |
close
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 25318 |
|---|---|
| Distinct (%) | 21.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12628.627 |
| Minimum | 0 |
|---|---|
| Maximum | 390490 |
| Zeros | 3524 |
| Zeros (%) | 2.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 136 |
| Q1 | 2375 |
| median | 4370 |
| Q3 | 9755 |
| 95-th percentile | 58493 |
| Maximum | 390490 |
| Range | 390490 |
| Interquartile range (IQR) | 7380 |
Descriptive statistics
| Standard deviation | 29293.248 |
|---|---|
| Coefficient of variation (CV) | 2.3195909 |
| Kurtosis | 32.76689 |
| Mean | 12628.627 |
| Median Absolute Deviation (MAD) | 2897 |
| Skewness | 5.1954049 |
| Sum | 1.5120886 × 109 |
| Variance | 8.5809435 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3524 | 2.9% |
| 400 | 414 | 0.3% |
| 3121 | 99 | 0.1% |
| 4070 | 93 | 0.1% |
| 4100 | 90 | 0.1% |
| 373.3 | 86 | 0.1% |
| 3745 | 82 | 0.1% |
| 3390 | 78 | 0.1% |
| 3197 | 70 | 0.1% |
| 1911 | 68 | 0.1% |
| Other values (25308) | 115131 |
| Value | Count | Frequency (%) |
| 0 | 3524 | |
| 42.05 | 1 | < 0.1% |
| 42.4 | 1 | < 0.1% |
| 42.85 | 1 | < 0.1% |
| 43.1 | 1 | < 0.1% |
| 43.3 | 1 | < 0.1% |
| 44.05 | 1 | < 0.1% |
| 44.1 | 1 | < 0.1% |
| 44.3 | 1 | < 0.1% |
| 44.7 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 390490 | 1 | |
| 357920 | 1 | |
| 357810 | 1 | |
| 352930 | 1 | |
| 350000 | 1 | |
| 349080 | 1 | |
| 348200 | 1 | |
| 346020 | 1 | |
| 345280 | 1 | |
| 344890 | 1 |
volume
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 73073 |
|---|---|
| Distinct (%) | 61.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 220428.39 |
| Minimum | 0 |
|---|---|
| Maximum | 11325298 |
| Zeros | 12864 |
| Zeros (%) | 10.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 722.5 |
| median | 30860 |
| Q3 | 206017 |
| 95-th percentile | 1032260.8 |
| Maximum | 11325298 |
| Range | 11325298 |
| Interquartile range (IQR) | 205294.5 |
Descriptive statistics
| Standard deviation | 523805.59 |
|---|---|
| Coefficient of variation (CV) | 2.3763073 |
| Kurtosis | 68.788783 |
| Mean | 220428.39 |
| Median Absolute Deviation (MAD) | 30860 |
| Skewness | 6.4771837 |
| Sum | 2.6392993 × 1010 |
| Variance | 2.7437229 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 12864 | 10.7% |
| 2 | 1061 | 0.9% |
| 4 | 745 | 0.6% |
| 1 | 596 | 0.5% |
| 6 | 517 | 0.4% |
| 8 | 431 | 0.4% |
| 10 | 364 | 0.3% |
| 3 | 302 | 0.3% |
| 14 | 272 | 0.2% |
| 12 | 267 | 0.2% |
| Other values (73063) | 102316 |
| Value | Count | Frequency (%) |
| 0 | 12864 | |
| 1 | 596 | 0.5% |
| 2 | 1061 | 0.9% |
| 3 | 302 | 0.3% |
| 4 | 745 | 0.6% |
| 5 | 212 | 0.2% |
| 6 | 517 | 0.4% |
| 7 | 181 | 0.2% |
| 8 | 431 | 0.4% |
| 9 | 133 | 0.1% |
| Value | Count | Frequency (%) |
| 11325298 | 1 | |
| 11215608 | 1 | |
| 10649982 | 1 | |
| 10298962 | 1 | |
| 10250286 | 1 | |
| 10220650 | 1 | |
| 10207570 | 1 | |
| 10040322 | 1 | |
| 9851786 | 1 | |
| 9812676 | 1 |
open_interest
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 78350 |
|---|---|
| Distinct (%) | 65.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 178405.61 |
| Minimum | 0 |
|---|---|
| Maximum | 4832902 |
| Zeros | 6918 |
| Zeros (%) | 5.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2602 |
| median | 45426 |
| Q3 | 181450 |
| 95-th percentile | 814721 |
| Maximum | 4832902 |
| Range | 4832902 |
| Interquartile range (IQR) | 178848 |
Descriptive statistics
| Standard deviation | 355776.66 |
|---|---|
| Coefficient of variation (CV) | 1.9942011 |
| Kurtosis | 25.848017 |
| Mean | 178405.61 |
| Median Absolute Deviation (MAD) | 45403 |
| Skewness | 4.281394 |
| Sum | 2.1361395 × 1010 |
| Variance | 1.2657703 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6918 | 5.8% |
| 2 | 1504 | 1.3% |
| 1 | 975 | 0.8% |
| 4 | 843 | 0.7% |
| 6 | 657 | 0.5% |
| 8 | 418 | 0.3% |
| 3 | 354 | 0.3% |
| 10 | 318 | 0.3% |
| 12 | 239 | 0.2% |
| 16 | 237 | 0.2% |
| Other values (78340) | 107272 |
| Value | Count | Frequency (%) |
| 0 | 6918 | |
| 1 | 975 | 0.8% |
| 2 | 1504 | 1.3% |
| 3 | 354 | 0.3% |
| 4 | 843 | 0.7% |
| 5 | 186 | 0.2% |
| 6 | 657 | 0.5% |
| 7 | 94 | 0.1% |
| 8 | 418 | 0.3% |
| 9 | 134 | 0.1% |
| Value | Count | Frequency (%) |
| 4832902 | 1 | |
| 4727336 | 1 | |
| 4711298 | 1 | |
| 4709702 | 1 | |
| 4577550 | 1 | |
| 4569212 | 1 | |
| 4552136 | 1 | |
| 4535336 | 1 | |
| 4533484 | 1 | |
| 4515004 | 1 |
turnover
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 105619 |
|---|---|
| Distinct (%) | 88.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.6175243 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.8410021 × 1011 |
| Zeros | 12864 |
| Zeros (%) | 10.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 20403.025 |
| median | 901751.06 |
| Q3 | 37248945 |
| 95-th percentile | 4.7699115 × 109 |
| Maximum | 1.8410021 × 1011 |
| Range | 1.8410021 × 1011 |
| Interquartile range (IQR) | 37228542 |
Descriptive statistics
| Standard deviation | 4.4653365 × 109 |
|---|---|
| Coefficient of variation (CV) | 4.6429168 |
| Kurtosis | 227.39624 |
| Mean | 9.6175243 × 108 |
| Median Absolute Deviation (MAD) | 901751.06 |
| Skewness | 12.148178 |
| Sum | 1.1515543 × 1014 |
| Variance | 1.993923 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 12864 | 10.7% |
| 3.2 | 12 | < 0.1% |
| 4.8 | 11 | < 0.1% |
| 4.2 | 7 | < 0.1% |
| 6.9 | 6 | < 0.1% |
| 7.56 | 5 | < 0.1% |
| 4.65 | 5 | < 0.1% |
| 11.83 | 5 | < 0.1% |
| 7.16 | 5 | < 0.1% |
| 4.51 | 5 | < 0.1% |
| Other values (105609) | 106810 |
| Value | Count | Frequency (%) |
| 0 | 12864 | |
| 1.24 | 1 | < 0.1% |
| 1.36 | 1 | < 0.1% |
| 1.37 | 2 | < 0.1% |
| 1.41 | 1 | < 0.1% |
| 1.71 | 1 | < 0.1% |
| 1.74 | 1 | < 0.1% |
| 1.77 | 1 | < 0.1% |
| 1.79 | 2 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.841002128 × 1011 | 1 | |
| 1.677204601 × 1011 | 1 | |
| 1.472793527 × 1011 | 1 | |
| 1.435022182 × 1011 | 1 | |
| 1.357605366 × 1011 | 1 | |
| 1.208361392 × 1011 | 1 | |
| 1.189071673 × 1011 | 1 | |
| 1.178495193 × 1011 | 1 | |
| 1.176288075 × 1011 | 1 | |
| 1.150501221 × 1011 | 1 |
settle
Real number (ℝ)
HIGH CORRELATION
| Distinct | 25710 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12727.673 |
| Minimum | 43 |
|---|---|
| Maximum | 370800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 43 |
|---|---|
| 5-th percentile | 365.9 |
| Q1 | 2510 |
| median | 4421 |
| Q3 | 9787.5 |
| 95-th percentile | 58500 |
| Maximum | 370800 |
| Range | 370757 |
| Interquartile range (IQR) | 7277.5 |
Descriptive statistics
| Standard deviation | 29252.474 |
|---|---|
| Coefficient of variation (CV) | 2.2983365 |
| Kurtosis | 32.747699 |
| Mean | 12727.673 |
| Median Absolute Deviation (MAD) | 2687 |
| Skewness | 5.1972063 |
| Sum | 1.5239479 × 109 |
| Variance | 8.5570726 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2479 | 422 | 0.4% |
| 400 | 412 | 0.3% |
| 3122 | 296 | 0.2% |
| 2662 | 255 | 0.2% |
| 801.4 | 250 | 0.2% |
| 3317 | 176 | 0.1% |
| 2360 | 135 | 0.1% |
| 3043 | 133 | 0.1% |
| 3198 | 113 | 0.1% |
| 3121 | 105 | 0.1% |
| Other values (25700) | 117438 |
| Value | Count | Frequency (%) |
| 43 | 1 | |
| 43.1 | 2 | |
| 43.25 | 1 | |
| 43.3 | 1 | |
| 43.35 | 1 | |
| 43.65 | 1 | |
| 44.05 | 1 | |
| 44.3 | 2 | |
| 44.35 | 1 | |
| 44.4 | 1 |
| Value | Count | Frequency (%) |
| 370800 | 1 | |
| 355130 | 1 | |
| 353120 | 1 | |
| 349200 | 1 | |
| 348660 | 1 | |
| 348290 | 1 | |
| 347770 | 1 | |
| 346050 | 1 | |
| 345830 | 1 | |
| 345820 | 1 |
pre_settle
Real number (ℝ)
HIGH CORRELATION
| Distinct | 25699 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12726.37 |
| Minimum | 43.1 |
|---|---|
| Maximum | 370800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 43.1 |
|---|---|
| 5-th percentile | 365.9 |
| Q1 | 2510 |
| median | 4420 |
| Q3 | 9790 |
| 95-th percentile | 58500 |
| Maximum | 370800 |
| Range | 370756.9 |
| Interquartile range (IQR) | 7280 |
Descriptive statistics
| Standard deviation | 29240.82 |
|---|---|
| Coefficient of variation (CV) | 2.297656 |
| Kurtosis | 32.715664 |
| Mean | 12726.37 |
| Median Absolute Deviation (MAD) | 2686 |
| Skewness | 5.1948672 |
| Sum | 1.5237919 × 109 |
| Variance | 8.5502556 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2479 | 421 | 0.4% |
| 400 | 412 | 0.3% |
| 3122 | 296 | 0.2% |
| 2662 | 255 | 0.2% |
| 801.4 | 250 | 0.2% |
| 3317 | 174 | 0.1% |
| 2360 | 137 | 0.1% |
| 3043 | 132 | 0.1% |
| 3198 | 112 | 0.1% |
| 3121 | 106 | 0.1% |
| Other values (25689) | 117440 |
| Value | Count | Frequency (%) |
| 43.1 | 2 | |
| 43.25 | 1 | |
| 43.35 | 1 | |
| 43.65 | 1 | |
| 44.05 | 1 | |
| 44.3 | 2 | |
| 44.35 | 1 | |
| 44.4 | 1 | |
| 44.7 | 1 | |
| 44.9 | 2 |
| Value | Count | Frequency (%) |
| 370800 | 1 | |
| 355130 | 1 | |
| 353120 | 1 | |
| 349200 | 1 | |
| 348660 | 1 | |
| 348290 | 1 | |
| 347770 | 1 | |
| 345830 | 1 | |
| 345820 | 1 | |
| 345120 | 1 |
variety
Text
| Distinct | 69 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.7 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.7386562 |
| Min length | 1 |
Characters and Unicode
| Total characters | 208178 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
| Value | Count | Frequency (%) |
| a | 3203 | 2.7% |
| l | 3203 | 2.7% |
| c | 3203 | 2.7% |
| rb | 3203 | 2.7% |
| m | 3203 | 2.7% |
| p | 3203 | 2.7% |
| v | 3203 | 2.7% |
| y | 3203 | 2.7% |
| au | 3203 | 2.7% |
| zn | 3203 | 2.7% |
| Other values (59) | 87705 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 21612 | 10.4% |
| C | 19265 | 9.3% |
| A | 18521 | 8.9% |
| P | 17442 | 8.4% |
| R | 17275 | 8.3% |
| U | 17218 | 8.3% |
| S | 12154 | 5.8% |
| J | 9818 | 4.7% |
| M | 9605 | 4.6% |
| N | 8671 | 4.2% |
| Other values (15) | 56597 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 208178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 21612 | 10.4% |
| C | 19265 | 9.3% |
| A | 18521 | 8.9% |
| P | 17442 | 8.4% |
| R | 17275 | 8.3% |
| U | 17218 | 8.3% |
| S | 12154 | 5.8% |
| J | 9818 | 4.7% |
| M | 9605 | 4.6% |
| N | 8671 | 4.2% |
| Other values (15) | 56597 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 208178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 21612 | 10.4% |
| C | 19265 | 9.3% |
| A | 18521 | 8.9% |
| P | 17442 | 8.4% |
| R | 17275 | 8.3% |
| U | 17218 | 8.3% |
| S | 12154 | 5.8% |
| J | 9818 | 4.7% |
| M | 9605 | 4.6% |
| N | 8671 | 4.2% |
| Other values (15) | 56597 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 208178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 21612 | 10.4% |
| C | 19265 | 9.3% |
| A | 18521 | 8.9% |
| P | 17442 | 8.4% |
| R | 17275 | 8.3% |
| U | 17218 | 8.3% |
| S | 12154 | 5.8% |
| J | 9818 | 4.7% |
| M | 9605 | 4.6% |
| N | 8671 | 4.2% |
| Other values (15) | 56597 |
delivery_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.9090324 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 935.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.5040229 |
|---|---|
| Coefficient of variation (CV) | 0.59299436 |
| Kurtosis | -1.2786073 |
| Mean | 5.9090324 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.017293249 |
| Sum | 707518 |
| Variance | 12.278176 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 1 | 23987 | |
| 9 | 23637 | |
| 5 | 23082 | |
| 10 | 8869 | 7.4% |
| 3 | 6764 | 5.6% |
| 7 | 6057 | 5.1% |
| 11 | 5559 | 4.6% |
| 12 | 5120 | 4.3% |
| 6 | 4838 | 4.0% |
| 2 | 4683 | 3.9% |
| Other values (2) | 7139 | 6.0% |
| Value | Count | Frequency (%) |
| 1 | 23987 | |
| 2 | 4683 | 3.9% |
| 3 | 6764 | 5.6% |
| 4 | 3522 | 2.9% |
| 5 | 23082 | |
| 6 | 4838 | 4.0% |
| 7 | 6057 | 5.1% |
| 8 | 3617 | 3.0% |
| 9 | 23637 | |
| 10 | 8869 | 7.4% |
| Value | Count | Frequency (%) |
| 12 | 5120 | 4.3% |
| 11 | 5559 | 4.6% |
| 10 | 8869 | 7.4% |
| 9 | 23637 | |
| 8 | 3617 | 3.0% |
| 7 | 6057 | 5.1% |
| 6 | 4838 | 4.0% |
| 5 | 23082 | |
| 4 | 3522 | 2.9% |
| 3 | 6764 | 5.6% |
| close | delivery_month | open_interest | pre_settle | settle | turnover | volume | |
|---|---|---|---|---|---|---|---|
| close | 1.000 | 0.011 | 0.145 | 0.977 | 0.977 | 0.458 | 0.147 |
| delivery_month | 0.011 | 1.000 | -0.085 | 0.017 | 0.017 | 0.032 | -0.080 |
| open_interest | 0.145 | -0.085 | 1.000 | 0.102 | 0.102 | 0.674 | 0.959 |
| pre_settle | 0.977 | 0.017 | 0.102 | 1.000 | 1.000 | 0.421 | 0.103 |
| settle | 0.977 | 0.017 | 0.102 | 1.000 | 1.000 | 0.421 | 0.103 |
| turnover | 0.458 | 0.032 | 0.674 | 0.421 | 0.421 | 1.000 | 0.702 |
| volume | 0.147 | -0.080 | 0.959 | 0.103 | 0.103 | 0.702 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | delivery_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | a1103 | 2011-01-04 00:00:00 | 4110.0 | 4135.0 | 4110.0 | 4128.0 | 5.0 | 108.0 | 20.62 | 4123.0 | 4117.0 | A | 3 |
| 1 | a1103 | 2011-01-05 00:00:00 | 4122.0 | 4122.0 | 4085.0 | 4091.0 | 18.0 | 105.0 | 73.82 | 4101.0 | 4123.0 | A | 3 |
| 2 | a1103 | 2011-01-06 00:00:00 | 4091.0 | 4091.0 | 4091.0 | 4091.0 | 1.0 | 105.0 | 4.09 | 4091.0 | 4101.0 | A | 3 |
| 3 | a1103 | 2011-01-07 00:00:00 | 4065.0 | 4095.0 | 4048.0 | 4048.0 | 16.0 | 99.0 | 65.14 | 4071.0 | 4091.0 | A | 3 |
| 4 | a1103 | 2011-01-10 00:00:00 | 4051.0 | 4074.0 | 4051.0 | 4064.0 | 13.0 | 90.0 | 52.86 | 4066.0 | 4071.0 | A | 3 |
| 5 | a1103 | 2011-01-11 00:00:00 | 4057.0 | 4060.0 | 4050.0 | 4050.0 | 4.0 | 90.0 | 16.22 | 4054.0 | 4066.0 | A | 3 |
| 6 | a1103 | 2011-01-12 00:00:00 | 4050.0 | 4070.0 | 4050.0 | 4070.0 | 14.0 | 77.0 | 56.91 | 4065.0 | 4054.0 | A | 3 |
| 7 | a1103 | 2011-01-13 00:00:00 | 4095.0 | 4099.0 | 4045.0 | 4081.0 | 14.0 | 76.0 | 57.16 | 4082.0 | 4065.0 | A | 3 |
| 8 | a1103 | 2011-01-14 00:00:00 | 4055.0 | 4088.0 | 4049.0 | 4085.0 | 11.0 | 74.0 | 44.75 | 4068.0 | 4082.0 | A | 3 |
| 9 | a1103 | 2011-01-17 00:00:00 | 4093.0 | 4100.0 | 4093.0 | 4095.0 | 12.0 | 77.0 | 49.17 | 4097.0 | 4068.0 | A | 3 |
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | delivery_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119725 | EC2404 | 2024-02-27 00:00:00 | 1949.9 | 1949.9 | 1862.0 | 1878.0 | 20603.0 | 22532.0 | 39182785.4 | 1901.8 | 1974.3 | EC | 4 |
| 119726 | EC2404 | 2024-02-28 00:00:00 | 1886.0 | 1945.0 | 1886.0 | 1931.7 | 14012.0 | 21725.0 | 26855399.2 | 1916.6 | 1901.8 | EC | 4 |
| 119727 | EC2404 | 2024-02-29 00:00:00 | 1931.3 | 1938.0 | 1890.0 | 1904.0 | 12112.0 | 20964.0 | 23158144.0 | 1912.0 | 1916.6 | EC | 4 |
| 119728 | EC2404 | 2024-03-01 00:00:00 | 1800.0 | 1855.4 | 1758.0 | 1780.0 | 17734.0 | 19494.0 | 32155288.8 | 1813.2 | 1912.0 | EC | 4 |
| 119729 | EC2404 | 2024-03-04 00:00:00 | 1802.0 | 1857.0 | 1731.8 | 1831.0 | 18882.0 | 19601.0 | 33785562.6 | 1789.3 | 1813.2 | EC | 4 |
| 119730 | EC2404 | 2024-03-05 00:00:00 | 1850.0 | 1891.2 | 1795.0 | 1802.5 | 15594.0 | 19452.0 | 28614990.0 | 1835.0 | 1789.3 | EC | 4 |
| 119731 | EC2404 | 2024-03-06 00:00:00 | 1731.0 | 1818.5 | 1731.0 | 1781.6 | 13140.0 | 19038.0 | 23349780.0 | 1777.0 | 1835.0 | EC | 4 |
| 119732 | EC2404 | 2024-03-07 00:00:00 | 1802.0 | 1866.1 | 1781.4 | 1794.3 | 15582.0 | 19549.0 | 28451173.8 | 1825.9 | 1777.0 | EC | 4 |
| 119733 | EC2404 | 2024-03-08 00:00:00 | 1808.0 | 1840.6 | 1802.0 | 1824.0 | 8168.0 | 18932.0 | 14883729.6 | 1822.2 | 1825.9 | EC | 4 |
| 119734 | EC2404 | 2024-03-11 00:00:00 | 1829.5 | 1899.0 | 1806.2 | 1815.0 | 15704.0 | 19135.0 | 29215721.6 | 1860.4 | 1822.2 | EC | 4 |